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