UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TRoqgk8CCVy1zVBQR69UAZJeBppQy/rAX33673HVHPo='
WHERE
key_id = 'ee8dccc070a60e5af033b7aadae9fe136602b1a6fd9d7246a5703825d3d245a7'
AND (
token = 'TRoqgk8CCVy1zVBQR69UAZJeBppQy/rAX33673HVHPo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)