UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VoDfEDpgVJTuy7XA/5fjhWiCJGf8oxb96Pr5fPVlhAY='
WHERE
key_id = 'a9be81181b628fc98a74ac4bf6cc8ee867aaf5f57055851f17f5a8ab0e6d4a7e'
AND (
token = 'VoDfEDpgVJTuy7XA/5fjhWiCJGf8oxb96Pr5fPVlhAY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)