UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wJuj1pgMj6M8XC4ZKFlPPQjPXmUKfc20a5DVt0eohK0='
WHERE
key_id = 'aadc3c2e98d9eb44b9711a4f4dd580876331f31b9c45e910ce88a6a054ab6042'
AND (
token = 'wJuj1pgMj6M8XC4ZKFlPPQjPXmUKfc20a5DVt0eohK0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)