UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iVqMez2vefBPwimTTxoPXXcoyzEGI9nyNpgC4veIjwI='
WHERE
key_id = '555afafb0e8a2c19afce5dd88e0a3ce753b22eb1d7dd2bb0d508b9b8eacf9d5c'
AND (
token = 'iVqMez2vefBPwimTTxoPXXcoyzEGI9nyNpgC4veIjwI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)