UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jx9g4OwiPxOqxTIak2c19FeFIKH1kQ/rURnZdfSPxCQ='
WHERE
key_id = '6523d80d59ca7535de1d7cd0244e9bccdba5396a5244d8b901b1d48fe2e2d851'
AND (
token = 'jx9g4OwiPxOqxTIak2c19FeFIKH1kQ/rURnZdfSPxCQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)