UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1G/XJxotBh/jlc4WUCyPeEa3c0JI2u23YoySgaZQfU8='
WHERE
key_id = '287d60e07bf052db9809147d1a0fa0b075f585c3ff7dd32de64f93c0624dfb0e'
AND (
token = '1G/XJxotBh/jlc4WUCyPeEa3c0JI2u23YoySgaZQfU8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)