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