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