UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mI8VyFXsuD2PVrJ5p4cuCdmhakkczEj9FvrwNuosEs8='
WHERE
key_id = 'dc510d7c257c4fccf52058413a58f6f1f8b35ae11f96ca976f4b4bc22ec03be3'
AND (
token = 'mI8VyFXsuD2PVrJ5p4cuCdmhakkczEj9FvrwNuosEs8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)