UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XW84aqLc71jrRJbXtj+BNYMJUtXQlC8QJjwqXTAQo9Y='
WHERE
key_id = '1946543d77a8314eb22c4e0f0ca51fc604d7ea771dffe1977e217fbdd6a96021'
AND (
token = 'XW84aqLc71jrRJbXtj+BNYMJUtXQlC8QJjwqXTAQo9Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)