UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4oXtVcBb4sBp4flaDmMcbWlejTYaeAW49c8nYUt6Qv8='
WHERE
key_id = '86ddd687cb84c08e746eb28892b219fe1478027f505ad5d3d315a5db07623333'
AND (
token = '4oXtVcBb4sBp4flaDmMcbWlejTYaeAW49c8nYUt6Qv8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)