UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'R8K5A/HCvd6kx9vvdLuTGWf3K8upApuqkoedRMDS17k='
WHERE
key_id = '7ccba06e75cc49eee6f5a0f3b3434aa7f9a5da370cccc01fca64dff369f4dfef'
AND (
token = 'R8K5A/HCvd6kx9vvdLuTGWf3K8upApuqkoedRMDS17k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)