UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'msG2mAtzmMArtzUNmAiKUXDoaISn0UXJpkIs3z7KGLs='
WHERE
key_id = '7bc51a2d03694a8548053e9172e7d4b1084abbfe04cffccee1f0c3b6f7abdf75'
AND (
token = 'msG2mAtzmMArtzUNmAiKUXDoaISn0UXJpkIs3z7KGLs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)