UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '68z6vwprw373jnCJhgZG8wusZTdusmp6eWDTA3tzQYs='
WHERE
key_id = '40a6b85a46836b4df53e7041cf5f4a92612899cab3725880fcd2523315dcf7f6'
AND (
token = '68z6vwprw373jnCJhgZG8wusZTdusmp6eWDTA3tzQYs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)