UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kNY9tHVRv8k9W8I4RC0TVr1f1TI6tUb5a3FXk26bgnQ='
WHERE
key_id = '46a3170ec0af0cca2f1c4ac686171750b173891d30ad500efd5f7b896c6836cd'
AND (
token = 'kNY9tHVRv8k9W8I4RC0TVr1f1TI6tUb5a3FXk26bgnQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)