UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zKMaJAHPYnHBDD6HljmgLxMputlHnmDGBpU/3i8dq94='
WHERE
key_id = 'd0668c98a15902442a7cf488f8e717d08d887894617390980d3b195902e4c6f1'
AND (
token = 'zKMaJAHPYnHBDD6HljmgLxMputlHnmDGBpU/3i8dq94='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)