UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2ngcVqFKs8Od/Y+kkZQ3qekGlAiXuVBWIdkYCNYXrEw='
WHERE
key_id = '830018c694dc71eb7dbdc73e6dbad9a53df3119293a8c65934cab5e42cccc32e'
AND (
token = '2ngcVqFKs8Od/Y+kkZQ3qekGlAiXuVBWIdkYCNYXrEw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)