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