UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nSHgd7GXoGXZYOOdoC3m3Em69AGRzA74gxk/QNKyRB0='
WHERE
key_id = '6878f5aecf0ec47297f41813839d25e8e3674d73b4f8ef43ba2ba08699bb4625'
AND (
token = 'nSHgd7GXoGXZYOOdoC3m3Em69AGRzA74gxk/QNKyRB0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)