UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bC1Jyry9cv3PT4qkDlVodSMYYNaM6NveBm1Ha09YmlA='
WHERE
key_id = '0f3f7662ccec0ea8c07fae6ed78c1c58fa80edf95480f284b5e270f440da5f2a'
AND (
token = 'bC1Jyry9cv3PT4qkDlVodSMYYNaM6NveBm1Ha09YmlA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)