UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fVNbK2mC10aiiuY3qYLUrK3Nl9YlkU6Tp90LQnRRssU='
WHERE
key_id = '0b522784f79718d4d985021c15e785e562554888aecb7635117e032aa64c1cd0'
AND (
token = 'fVNbK2mC10aiiuY3qYLUrK3Nl9YlkU6Tp90LQnRRssU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)