UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xQN3zYqjRBcNc6Rd8FeVR/sBE0gxw2gIOWZt64KTRgI='
WHERE
key_id = 'd2553bc7ce7569e20085bf126f915d6c5bf2b501b94c3df057d661c87883502e'
AND (
token = 'xQN3zYqjRBcNc6Rd8FeVR/sBE0gxw2gIOWZt64KTRgI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)