UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C0cOwQQidnIYYLGqNpkyOBdgw1A6/RcXm6QYIYNnXcA='
WHERE
key_id = '2a7aef23fccbcb4797248ab3691640fd176188461d837665cb13a7b30e571357'
AND (
token = 'C0cOwQQidnIYYLGqNpkyOBdgw1A6/RcXm6QYIYNnXcA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)