UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6OwGEyZb3pLjAUCJcJ4jnTDI/53xTY9bv16IiIB38bY='
WHERE
key_id = '7ae70ca497a35e78bfc1fea809dc7b2c9b4b469becf7bd1efdcc20b35034e77c'
AND (
token = '6OwGEyZb3pLjAUCJcJ4jnTDI/53xTY9bv16IiIB38bY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)