UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bZq1Isb0p9VcaDj027y2sF0a/GaHsIJcKlo4Viu53is='
WHERE
key_id = 'c2a620c5dd2876656b6e8ce65a52fe2eab79ca21ca79b39f107e44c551c36fdd'
AND (
token = 'bZq1Isb0p9VcaDj027y2sF0a/GaHsIJcKlo4Viu53is='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)