UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zELR3LYuDB1+foL4lcUM/EaDlu3hq7d/Pul5OM+ckuM='
WHERE
key_id = 'a9063d93fe9851d4243e55e1c4b67dc4cd012dabd3a324c8b3ce750db87d3666'
AND (
token = 'zELR3LYuDB1+foL4lcUM/EaDlu3hq7d/Pul5OM+ckuM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)