UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uEPgBdfAnN/8PTaqPIKuXxlorcqmUYD9Eeu3frHeoUw='
WHERE
key_id = 'aff09a707f9fc84e5d1172825a48cff1841369482cdc554c4dda024474e50de1'
AND (
token = 'uEPgBdfAnN/8PTaqPIKuXxlorcqmUYD9Eeu3frHeoUw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)