UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'v3PdDYE6zVdXvDnNXCsCc1evHvkWQmrLu3GcW7T445M='
WHERE
key_id = '78d7852be96732094b6c4bca22c88b20cea69a30572dab1dfa023b1d21ffbb4c'
AND (
token = 'v3PdDYE6zVdXvDnNXCsCc1evHvkWQmrLu3GcW7T445M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)