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