UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pcF/ZVB4cv4jLr/2AVcYyk289dTDcENPgzV4ekrtwvo='
WHERE
key_id = 'a77ff4d93824380fc15c0f2f4eebc30c504661a5ff11f5d1314f4443787fcbae'
AND (
token = 'pcF/ZVB4cv4jLr/2AVcYyk289dTDcENPgzV4ekrtwvo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)