UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3MYauRIe3LMvsA2oPh4p/iNROHWekd/FmdsPRWDo+oU='
WHERE
key_id = '9a672b3b45ddd87eda3e5c9a44202c72068d2faed9e8eff1bf770fa74f78555b'
AND (
token = '3MYauRIe3LMvsA2oPh4p/iNROHWekd/FmdsPRWDo+oU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)