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