UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BlCBcAV4gFN8HD0hHcM2Jhg4gmzg+IKSAGqIPQBowys='
WHERE
key_id = 'b7637ee3446a62c23611f641caa65cbbae2643d98419603d684ac172dd2522a6'
AND (
token = 'BlCBcAV4gFN8HD0hHcM2Jhg4gmzg+IKSAGqIPQBowys='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)