UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vGZDz9BY4qaBY+QU9mmwOCxsOsiVcPe671GtatNZI+8='
WHERE
key_id = '0bf1501b455306ab6977665213111a98d3bb96d9c4d15e763b8b67841098396a'
AND (
token = 'vGZDz9BY4qaBY+QU9mmwOCxsOsiVcPe671GtatNZI+8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)