UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9yEHrQEdSjJgpVQqmUqnoC+47kMx4JJ5VOHGvN4DAHE='
WHERE
key_id = '93e3c297c6fcd04f9910c43d2a4ad1c612e139670160673d1ee2c84153470310'
AND (
token = '9yEHrQEdSjJgpVQqmUqnoC+47kMx4JJ5VOHGvN4DAHE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)