UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0WS9WdNtoFE69IXVcFZCmxbwKiXXA3PTNRwhJB18v90='
WHERE
key_id = '01520f196ffe8960782feb1d9449b0e3c70500417effd4a0197f8e2fd58b69ee'
AND (
token = '0WS9WdNtoFE69IXVcFZCmxbwKiXXA3PTNRwhJB18v90='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)