UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'upWYfNFTjbGSerhvs7H0IITO8/CVSyb2huvXY0s6Etc='
WHERE
key_id = 'e7381683d2f04790af2f2634d50863825df3ba157012875e10aca0e548dfa16a'
AND (
token = 'upWYfNFTjbGSerhvs7H0IITO8/CVSyb2huvXY0s6Etc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)